This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
The reason your return value is 1, is that the statement that supplies the formula result is the @For statement, which apparently returns a number value. You might do better to remove the "returnList:=" from the last statement.
I see a strange statement inside the @For that uses := twice. I assume the second one was meant to be a :.
You're doing the same lookup each time thru the loop. You have a loop index i, but you don't use it for anything. Perhaps you meant to use keyList[i] instead of key.
You need to do something to handle a failure of @DbLookup, e.g. using @IfError.
Return to top
. . RE: Multi Key for Dblookup (~Bill Frokimari... 6.Nov.03) 
Print this page
